﻿CREATE TABLE [dbo].[ReferralSites] (
    [Id]                  INT           IDENTITY (1, 1) NOT NULL,
    [Name]                VARCHAR (50)  NOT NULL,
    [RootUrl]             VARCHAR (MAX) NOT NULL,
    [ReferralLinkPattern] VARCHAR (MAX) NOT NULL,
    CONSTRAINT [PK_ReferralSite] PRIMARY KEY CLUSTERED ([Id] ASC)
);

